﻿using Maticsoft.DBUtility;
using System;
using System.Collections.Generic;
using System.Data;
using System.Text;

namespace Maticsoft222.DAL
{
    public class UserRole
    {
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string rolecode)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from Rights where code in(select rightscode from dbo.RoleRightRelation where rolecode='" + rolecode + "' group by rightscode) order by sort asc");
        
            return DbHelperSQL.Query(strSql.ToString());
        }

    }
}
